/********************************************************************
  Copyright by PCI, 2002-10-08
  File Name: db_ppm_price_desc_item_spec.cxx
  Created Date: 2002-10-08 
  Author: Machine
  Version: 1.0 
  Last Version Date: 
  Version Date:
*******************************************************************/
/********************************************************************
  Copyright by PCI, 2002-10-08
  Class Name: CTable_PPM_PRICE_DESC_ITEM_SPEC
  Created Date: 2002-10-08 
  Author: Machine
  Defined File: db_ppm_price_desc_item_spec.hxx
  Last Version Date: 
  Version Date:
*******************************************************************/
#include "table_ppm.h" 

CTable_PPM_PRICE_DESC_ITEM_SPEC::CTable_PPM_PRICE_DESC_ITEM_SPEC( )
 :NPCRecordSet( )
{
  setTableName( "PPM_PRICE_DESC_ITEM_SPEC" );
  prepareTable();
  prepareQuery();
 
  ID.setField( "ID", DATA_CHAR, 20, 1 );
  makeTableItem( ID );
  makeKeyItem( ID ); 
  NAME.setField( "NAME", DATA_CHAR, 512, 0 );
  makeTableItem( NAME );
  TYPE.setField( "TYPE", DATA_CHAR, 10, 0 );
  makeTableItem( TYPE );
  EVENT_TYPE.setField( "EVENT_TYPE", DATA_CHAR, 512, 0 );
  makeTableItem( EVENT_TYPE );
  EXT_INFO.setField( "EXT_INFO", DATA_CHAR, 512, 0 );
  makeTableItem( EXT_INFO );
  CUSTOM_INFO.setField( "CUSTOM_INFO", DATA_CHAR, 512, 0 );
  makeTableItem( CUSTOM_INFO );
  CONSUMPTION.setField( "CONSUMPTION", DATA_CHAR, 20, 0 );
  makeTableItem( CONSUMPTION );
  PRICE_INFO.setField( "PRICE_INFO", DATA_CHAR, 20, 0 );
  makeTableItem( PRICE_INFO );
  EXECUTE_TYPE.setField( "EXECUTE_TYPE", DATA_CHAR, 6, 0 );
  makeTableItem( EXECUTE_TYPE );
  COMPUTE_TYPE.setField( "COMPUTE_TYPE", DATA_CHAR, 6, 0 );
  makeTableItem( COMPUTE_TYPE );
  DESCRIPTION.setField( "DESCRIPTION", DATA_CHAR, 512, 0 );
  makeTableItem( DESCRIPTION );
  STAFF.setField( "STAFF", DATA_CHAR, 20, 0 );
  makeTableItem( STAFF );
  CREATE_DATE.setField( "CREATE_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( CREATE_DATE );
  MODIFY_DATE.setField( "MODIFY_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( MODIFY_DATE );
  STATE.setField( "STATE", DATA_CHAR, 6, 0 );
  makeTableItem( STATE );
  EFF_DATE.setField( "EFF_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( EFF_DATE );
  EXP_DATE.setField( "EXP_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( EXP_DATE );
  REMARK.setField( "REMARK", DATA_CHAR, 1000, 0 );
  makeTableItem( REMARK );
}


CTable_PPM_PRICE_DESC_ITEM_SPEC::CTable_PPM_PRICE_DESC_ITEM_SPEC( NPConnection& pcldb )
 :NPCRecordSet( pcldb )
{
  setTableName( "PPM_PRICE_DESC_ITEM_SPEC" );
  prepareTable();
  prepareQuery();
 
  ID.setField( "ID", DATA_CHAR, 20, 1 );
  makeTableItem( ID );
  makeKeyItem( ID ); 
  NAME.setField( "NAME", DATA_CHAR, 512, 0 );
  makeTableItem( NAME );
  TYPE.setField( "TYPE", DATA_CHAR, 10, 0 );
  makeTableItem( TYPE );
  EVENT_TYPE.setField( "EVENT_TYPE", DATA_CHAR, 512, 0 );
  makeTableItem( EVENT_TYPE );
  EXT_INFO.setField( "EXT_INFO", DATA_CHAR, 512, 0 );
  makeTableItem( EXT_INFO );
  CUSTOM_INFO.setField( "CUSTOM_INFO", DATA_CHAR, 512, 0 );
  makeTableItem( CUSTOM_INFO );
  CONSUMPTION.setField( "CONSUMPTION", DATA_CHAR, 20, 0 );
  makeTableItem( CONSUMPTION );
  PRICE_INFO.setField( "PRICE_INFO", DATA_CHAR, 20, 0 );
  makeTableItem( PRICE_INFO );
  EXECUTE_TYPE.setField( "EXECUTE_TYPE", DATA_CHAR, 6, 0 );
  makeTableItem( EXECUTE_TYPE );
  COMPUTE_TYPE.setField( "COMPUTE_TYPE", DATA_CHAR, 6, 0 );
  makeTableItem( COMPUTE_TYPE );
  DESCRIPTION.setField( "DESCRIPTION", DATA_CHAR, 512, 0 );
  makeTableItem( DESCRIPTION );
  STAFF.setField( "STAFF", DATA_CHAR, 20, 0 );
  makeTableItem( STAFF );
  CREATE_DATE.setField( "CREATE_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( CREATE_DATE );
  MODIFY_DATE.setField( "MODIFY_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( MODIFY_DATE );
  STATE.setField( "STATE", DATA_CHAR, 6, 0 );
  makeTableItem( STATE );
  EFF_DATE.setField( "EFF_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( EFF_DATE );
  EXP_DATE.setField( "EXP_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( EXP_DATE );
  REMARK.setField( "REMARK", DATA_CHAR, 1000, 0 );
  makeTableItem( REMARK );
}

CTable_PPM_PRICE_DESC_ITEM_SPEC::~CTable_PPM_PRICE_DESC_ITEM_SPEC( )
{
    close();
}

